CVS Match Columns Registry entry

Specifies a pair of columns that match between the CVS database and Registration tables.

The Certificate Validation Service (CVS) attempts to match queries from external agencies with certificates held by a Vital Records Office. Where a match does not occur or multiple matches occur with the information supplied, the data is stored in the ecvsexceptions database for further review by registrations staff.

This entry defines a mapping between a column in the CVS database and a column in a registration table so that an attempt can be made to match the information supplied to CVS with data held in the registration table.

Usage

This Registry entry is assigned to groups:

KeyGroup
Key 1 Group
Key 2 Default
Key 3 Table
Key 4 table
Key 5 CVS Match Columns
Key 6CVS column
Value column
GroupDefaultTabletableCVS Match ColumnsCVS columncolumn

where:

CVS column

is the name of a column in the CVS database.

column

is the name of a column in the registration table specified in table which matches with CVS column.

Note: This entry is required as the same columns are used in the CVS exceptions database for births, deaths and marriages.

Example

This entry specifies that the CVS exceptions column CVSLastName matches with ChildSurname in the Births database:

KeySetting
Key 1 Group
Key 2 Default
Key 3 Table
Key 4 ebirths
Key 5 CVS Match Columns
Key 6CVSLastName
Value ChildSurname